﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Pedido" targetNamespace="http://tempuri.org/Pedido.xsd" xmlns:mstns="http://tempuri.org/Pedido.xsd" xmlns="http://tempuri.org/Pedido.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ERP_MOVILConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ERP_MOVILConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MMSA.Entities.Properties.Settings.GlobalReference.Default.ERP_MOVILConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PED_PEDIDOTableAdapter" GeneratorDataComponentClassName="PED_PEDIDOTableAdapter" Name="PED_PEDIDO" UserDataComponentName="PED_PEDIDOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ERP_MOVILConnectionString (Settings)" DbObjectName="ERP_MOVIL.dbo.PED_PEDIDO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PED_PEDIDO] WHERE (([ped_id] = @Original_ped_id) AND ((@IsNull_usu_id = 1 AND [usu_id] IS NULL) OR ([usu_id] = @Original_usu_id)) AND ((@IsNull_loc_id = 1 AND [loc_id] IS NULL) OR ([loc_id] = @Original_loc_id)) AND ((@IsNull_ped_fecha_creacion = 1 AND [ped_fecha_creacion] IS NULL) OR ([ped_fecha_creacion] = @Original_ped_fecha_creacion)) AND ((@IsNull_ped_fecha_pago = 1 AND [ped_fecha_pago] IS NULL) OR ([ped_fecha_pago] = @Original_ped_fecha_pago)) AND ((@IsNull_ped_fecha_aprovacion = 1 AND [ped_fecha_aprovacion] IS NULL) OR ([ped_fecha_aprovacion] = @Original_ped_fecha_aprovacion)) AND ((@IsNull_ped_descuento = 1 AND [ped_descuento] IS NULL) OR ([ped_descuento] = @Original_ped_descuento)) AND ((@IsNull_ped_subtotal = 1 AND [ped_subtotal] IS NULL) OR ([ped_subtotal] = @Original_ped_subtotal)) AND ((@IsNull_ped_impuesto = 1 AND [ped_impuesto] IS NULL) OR ([ped_impuesto] = @Original_ped_impuesto)) AND ((@IsNull_ped_total = 1 AND [ped_total] IS NULL) OR ([ped_total] = @Original_ped_total)) AND ((@IsNull_ped_idm = 1 AND [ped_idm] IS NULL) OR ([ped_idm] = @Original_ped_idm)) AND ((@IsNull_ped_latitud = 1 AND [ped_latitud] IS NULL) OR ([ped_latitud] = @Original_ped_latitud)) AND ((@IsNull_ped_longitud = 1 AND [ped_longitud] IS NULL) OR ([ped_longitud] = @Original_ped_longitud)) AND ((@IsNull_ped_fecha_inicio = 1 AND [ped_fecha_inicio] IS NULL) OR ([ped_fecha_inicio] = @Original_ped_fecha_inicio)) AND ((@IsNull_ped_fecha_fin = 1 AND [ped_fecha_fin] IS NULL) OR ([ped_fecha_fin] = @Original_ped_fecha_fin)) AND ((@IsNull_ped_estado = 1 AND [ped_estado] IS NULL) OR ([ped_estado] = @Original_ped_estado)) AND ((@IsNull_ped_id_usu_descarga = 1 AND [ped_id_usu_descarga] IS NULL) OR ([ped_id_usu_descarga] = @Original_ped_id_usu_descarga)) AND ((@IsNull_ped_fecha_descarga = 1 AND [ped_fecha_descarga] IS NULL) OR ([ped_fecha_descarga] = @Original_ped_fecha_descarga)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ped_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_usu_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usu_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_usu_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usu_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_creacion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_creacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_creacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_creacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_pago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_pago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_pago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_pago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_aprovacion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_aprovacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_aprovacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_aprovacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_descuento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_descuento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_descuento" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_descuento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_subtotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_subtotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_subtotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_subtotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_impuesto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_impuesto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_impuesto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_impuesto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_total" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_total" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_idm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_idm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ped_idm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ped_idm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_latitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_latitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ped_latitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_latitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_longitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_longitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ped_longitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_longitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_inicio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_inicio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_inicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_inicio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_fin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_fin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_fin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_fin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ped_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_id_usu_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id_usu_descarga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ped_id_usu_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id_usu_descarga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_descarga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_descarga" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_descarga" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PED_PEDIDO] ([ped_id], [usu_id], [loc_id], [ped_fecha_creacion], [ped_fecha_pago], [ped_fecha_aprovacion], [ped_descuento], [ped_subtotal], [ped_impuesto], [ped_total], [ped_idm], [ped_latitud], [ped_longitud], [ped_fecha_inicio], [ped_fecha_fin], [ped_estado], [ped_id_usu_descarga], [ped_fecha_descarga]) VALUES (@ped_id, @usu_id, @loc_id, @ped_fecha_creacion, @ped_fecha_pago, @ped_fecha_aprovacion, @ped_descuento, @ped_subtotal, @ped_impuesto, @ped_total, @ped_idm, @ped_latitud, @ped_longitud, @ped_fecha_inicio, @ped_fecha_fin, @ped_estado, @ped_id_usu_descarga, @ped_fecha_descarga);
SELECT ped_id, usu_id, loc_id, ped_fecha_creacion, ped_fecha_pago, ped_fecha_aprovacion, ped_descuento, ped_subtotal, ped_impuesto, ped_total, ped_idm, ped_latitud, ped_longitud, ped_fecha_inicio, ped_fecha_fin, ped_estado, ped_id_usu_descarga, ped_fecha_descarga FROM PED_PEDIDO WHERE (ped_id = @ped_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ped_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@usu_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usu_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_creacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_creacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_pago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_pago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_aprovacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_aprovacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_descuento" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_descuento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_subtotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_subtotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_impuesto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_impuesto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_total" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ped_idm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ped_idm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ped_latitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_latitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ped_longitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_longitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_inicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_inicio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_fin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_fin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ped_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ped_id_usu_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id_usu_descarga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_descarga" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_descarga" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ped_id, usu_id, loc_id, ped_fecha_creacion, ped_fecha_pago, ped_fecha_aprovacion, ped_descuento, ped_subtotal, ped_impuesto, ped_total, ped_idm, ped_latitud, ped_longitud, ped_fecha_inicio, ped_fecha_fin, ped_estado, ped_id_usu_descarga, ped_fecha_descarga FROM dbo.PED_PEDIDO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PED_PEDIDO] SET [ped_id] = @ped_id, [usu_id] = @usu_id, [loc_id] = @loc_id, [ped_fecha_creacion] = @ped_fecha_creacion, [ped_fecha_pago] = @ped_fecha_pago, [ped_fecha_aprovacion] = @ped_fecha_aprovacion, [ped_descuento] = @ped_descuento, [ped_subtotal] = @ped_subtotal, [ped_impuesto] = @ped_impuesto, [ped_total] = @ped_total, [ped_idm] = @ped_idm, [ped_latitud] = @ped_latitud, [ped_longitud] = @ped_longitud, [ped_fecha_inicio] = @ped_fecha_inicio, [ped_fecha_fin] = @ped_fecha_fin, [ped_estado] = @ped_estado, [ped_id_usu_descarga] = @ped_id_usu_descarga, [ped_fecha_descarga] = @ped_fecha_descarga WHERE (([ped_id] = @Original_ped_id) AND ((@IsNull_usu_id = 1 AND [usu_id] IS NULL) OR ([usu_id] = @Original_usu_id)) AND ((@IsNull_loc_id = 1 AND [loc_id] IS NULL) OR ([loc_id] = @Original_loc_id)) AND ((@IsNull_ped_fecha_creacion = 1 AND [ped_fecha_creacion] IS NULL) OR ([ped_fecha_creacion] = @Original_ped_fecha_creacion)) AND ((@IsNull_ped_fecha_pago = 1 AND [ped_fecha_pago] IS NULL) OR ([ped_fecha_pago] = @Original_ped_fecha_pago)) AND ((@IsNull_ped_fecha_aprovacion = 1 AND [ped_fecha_aprovacion] IS NULL) OR ([ped_fecha_aprovacion] = @Original_ped_fecha_aprovacion)) AND ((@IsNull_ped_descuento = 1 AND [ped_descuento] IS NULL) OR ([ped_descuento] = @Original_ped_descuento)) AND ((@IsNull_ped_subtotal = 1 AND [ped_subtotal] IS NULL) OR ([ped_subtotal] = @Original_ped_subtotal)) AND ((@IsNull_ped_impuesto = 1 AND [ped_impuesto] IS NULL) OR ([ped_impuesto] = @Original_ped_impuesto)) AND ((@IsNull_ped_total = 1 AND [ped_total] IS NULL) OR ([ped_total] = @Original_ped_total)) AND ((@IsNull_ped_idm = 1 AND [ped_idm] IS NULL) OR ([ped_idm] = @Original_ped_idm)) AND ((@IsNull_ped_latitud = 1 AND [ped_latitud] IS NULL) OR ([ped_latitud] = @Original_ped_latitud)) AND ((@IsNull_ped_longitud = 1 AND [ped_longitud] IS NULL) OR ([ped_longitud] = @Original_ped_longitud)) AND ((@IsNull_ped_fecha_inicio = 1 AND [ped_fecha_inicio] IS NULL) OR ([ped_fecha_inicio] = @Original_ped_fecha_inicio)) AND ((@IsNull_ped_fecha_fin = 1 AND [ped_fecha_fin] IS NULL) OR ([ped_fecha_fin] = @Original_ped_fecha_fin)) AND ((@IsNull_ped_estado = 1 AND [ped_estado] IS NULL) OR ([ped_estado] = @Original_ped_estado)) AND ((@IsNull_ped_id_usu_descarga = 1 AND [ped_id_usu_descarga] IS NULL) OR ([ped_id_usu_descarga] = @Original_ped_id_usu_descarga)) AND ((@IsNull_ped_fecha_descarga = 1 AND [ped_fecha_descarga] IS NULL) OR ([ped_fecha_descarga] = @Original_ped_fecha_descarga)));
SELECT ped_id, usu_id, loc_id, ped_fecha_creacion, ped_fecha_pago, ped_fecha_aprovacion, ped_descuento, ped_subtotal, ped_impuesto, ped_total, ped_idm, ped_latitud, ped_longitud, ped_fecha_inicio, ped_fecha_fin, ped_estado, ped_id_usu_descarga, ped_fecha_descarga FROM PED_PEDIDO WHERE (ped_id = @ped_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ped_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@usu_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usu_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_creacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_creacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_pago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_pago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_aprovacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_aprovacion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_descuento" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_descuento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_subtotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_subtotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_impuesto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_impuesto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ped_total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_total" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ped_idm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ped_idm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ped_latitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_latitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ped_longitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_longitud" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_inicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_inicio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_fin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_fin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ped_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ped_id_usu_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id_usu_descarga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ped_fecha_descarga" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_descarga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ped_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_usu_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usu_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_usu_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usu_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_loc_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loc_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_creacion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_creacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_creacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_creacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_pago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_pago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_pago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_pago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_aprovacion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_aprovacion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_aprovacion" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_aprovacion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_descuento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_descuento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_descuento" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_descuento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_subtotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_subtotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_subtotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_subtotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_impuesto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_impuesto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_impuesto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_impuesto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_total" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ped_total" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ped_total" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_idm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_idm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ped_idm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ped_idm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_latitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_latitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ped_latitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_latitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_longitud" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_longitud" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ped_longitud" Precision="18" ProviderType="Decimal" Scale="16" Size="0" SourceColumn="ped_longitud" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_inicio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_inicio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_inicio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_inicio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_fin" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_fin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_fin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_fin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ped_estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_id_usu_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id_usu_descarga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ped_id_usu_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_id_usu_descarga" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ped_fecha_descarga" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ped_fecha_descarga" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ped_fecha_descarga" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ped_fecha_descarga" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ped_id" DataSetColumn="ped_id" />
              <Mapping SourceColumn="usu_id" DataSetColumn="usu_id" />
              <Mapping SourceColumn="loc_id" DataSetColumn="loc_id" />
              <Mapping SourceColumn="ped_fecha_creacion" DataSetColumn="ped_fecha_creacion" />
              <Mapping SourceColumn="ped_fecha_pago" DataSetColumn="ped_fecha_pago" />
              <Mapping SourceColumn="ped_fecha_aprovacion" DataSetColumn="ped_fecha_aprovacion" />
              <Mapping SourceColumn="ped_descuento" DataSetColumn="ped_descuento" />
              <Mapping SourceColumn="ped_subtotal" DataSetColumn="ped_subtotal" />
              <Mapping SourceColumn="ped_impuesto" DataSetColumn="ped_impuesto" />
              <Mapping SourceColumn="ped_total" DataSetColumn="ped_total" />
              <Mapping SourceColumn="ped_idm" DataSetColumn="ped_idm" />
              <Mapping SourceColumn="ped_latitud" DataSetColumn="ped_latitud" />
              <Mapping SourceColumn="ped_longitud" DataSetColumn="ped_longitud" />
              <Mapping SourceColumn="ped_fecha_inicio" DataSetColumn="ped_fecha_inicio" />
              <Mapping SourceColumn="ped_fecha_fin" DataSetColumn="ped_fecha_fin" />
              <Mapping SourceColumn="ped_estado" DataSetColumn="ped_estado" />
              <Mapping SourceColumn="ped_id_usu_descarga" DataSetColumn="ped_id_usu_descarga" />
              <Mapping SourceColumn="ped_fecha_descarga" DataSetColumn="ped_fecha_descarga" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ERP_MOVILConnectionString (Settings)" DbObjectName="ERP_MOVIL.dbo.sp_inserta_detalle_pedido" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_inserta_detalle_pedido" Modifier="Public" Name="sp_inserta_detalle_pedido" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="sp_inserta_detalle_pedido">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_inserta_detalle_pedido</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ws_ped_id" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ws_pro_id" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ws_cant" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ERP_MOVILConnectionString (Settings)" DbObjectName="ERP_MOVIL.dbo.sp_inserta_pedido" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="sp_inserta_pedido" Modifier="Public" Name="sp_inserta_pedido" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sp_inserta_pedido">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_inserta_pedido</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ws_ped_id" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ws_usu" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ws_loc_id" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@ws_latitude" Precision="18" ProviderType="Decimal" Scale="16" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@ws_longitude" Precision="18" ProviderType="Decimal" Scale="16" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ws_fecha_inicio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ws_fecha_fin" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Pedido" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Pedido" msprop:Generator_UserDSName="Pedido">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PED_PEDIDO" msprop:Generator_TableClassName="PED_PEDIDODataTable" msprop:Generator_TableVarName="tablePED_PEDIDO" msprop:Generator_RowChangedName="PED_PEDIDORowChanged" msprop:Generator_TablePropName="PED_PEDIDO" msprop:Generator_RowDeletingName="PED_PEDIDORowDeleting" msprop:Generator_RowChangingName="PED_PEDIDORowChanging" msprop:Generator_RowEvHandlerName="PED_PEDIDORowChangeEventHandler" msprop:Generator_RowDeletedName="PED_PEDIDORowDeleted" msprop:Generator_RowClassName="PED_PEDIDORow" msprop:Generator_UserTableName="PED_PEDIDO" msprop:Generator_RowEvArgName="PED_PEDIDORowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ped_id" msprop:Generator_ColumnVarNameInTable="columnped_id" msprop:Generator_ColumnPropNameInRow="ped_id" msprop:Generator_ColumnPropNameInTable="ped_idColumn" msprop:Generator_UserColumnName="ped_id" type="xs:int" />
              <xs:element name="usu_id" msprop:Generator_ColumnVarNameInTable="columnusu_id" msprop:Generator_ColumnPropNameInRow="usu_id" msprop:Generator_ColumnPropNameInTable="usu_idColumn" msprop:Generator_UserColumnName="usu_id" type="xs:int" minOccurs="0" />
              <xs:element name="loc_id" msprop:Generator_ColumnVarNameInTable="columnloc_id" msprop:Generator_ColumnPropNameInRow="loc_id" msprop:Generator_ColumnPropNameInTable="loc_idColumn" msprop:Generator_UserColumnName="loc_id" type="xs:int" minOccurs="0" />
              <xs:element name="ped_fecha_creacion" msprop:Generator_ColumnVarNameInTable="columnped_fecha_creacion" msprop:Generator_ColumnPropNameInRow="ped_fecha_creacion" msprop:Generator_ColumnPropNameInTable="ped_fecha_creacionColumn" msprop:Generator_UserColumnName="ped_fecha_creacion" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ped_fecha_pago" msprop:Generator_ColumnVarNameInTable="columnped_fecha_pago" msprop:Generator_ColumnPropNameInRow="ped_fecha_pago" msprop:Generator_ColumnPropNameInTable="ped_fecha_pagoColumn" msprop:Generator_UserColumnName="ped_fecha_pago" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ped_fecha_aprovacion" msprop:Generator_ColumnVarNameInTable="columnped_fecha_aprovacion" msprop:Generator_ColumnPropNameInRow="ped_fecha_aprovacion" msprop:Generator_ColumnPropNameInTable="ped_fecha_aprovacionColumn" msprop:Generator_UserColumnName="ped_fecha_aprovacion" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ped_descuento" msprop:Generator_ColumnVarNameInTable="columnped_descuento" msprop:Generator_ColumnPropNameInRow="ped_descuento" msprop:Generator_ColumnPropNameInTable="ped_descuentoColumn" msprop:Generator_UserColumnName="ped_descuento" type="xs:double" minOccurs="0" />
              <xs:element name="ped_subtotal" msprop:Generator_ColumnVarNameInTable="columnped_subtotal" msprop:Generator_ColumnPropNameInRow="ped_subtotal" msprop:Generator_ColumnPropNameInTable="ped_subtotalColumn" msprop:Generator_UserColumnName="ped_subtotal" type="xs:double" minOccurs="0" />
              <xs:element name="ped_impuesto" msprop:Generator_ColumnVarNameInTable="columnped_impuesto" msprop:Generator_ColumnPropNameInRow="ped_impuesto" msprop:Generator_ColumnPropNameInTable="ped_impuestoColumn" msprop:Generator_UserColumnName="ped_impuesto" type="xs:double" minOccurs="0" />
              <xs:element name="ped_total" msprop:Generator_ColumnVarNameInTable="columnped_total" msprop:Generator_ColumnPropNameInRow="ped_total" msprop:Generator_ColumnPropNameInTable="ped_totalColumn" msprop:Generator_UserColumnName="ped_total" type="xs:double" minOccurs="0" />
              <xs:element name="ped_idm" msprop:Generator_ColumnVarNameInTable="columnped_idm" msprop:Generator_ColumnPropNameInRow="ped_idm" msprop:Generator_ColumnPropNameInTable="ped_idmColumn" msprop:Generator_UserColumnName="ped_idm" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ped_latitud" msprop:Generator_ColumnVarNameInTable="columnped_latitud" msprop:Generator_ColumnPropNameInRow="ped_latitud" msprop:Generator_ColumnPropNameInTable="ped_latitudColumn" msprop:Generator_UserColumnName="ped_latitud" type="xs:decimal" minOccurs="0" />
              <xs:element name="ped_longitud" msprop:Generator_ColumnVarNameInTable="columnped_longitud" msprop:Generator_ColumnPropNameInRow="ped_longitud" msprop:Generator_ColumnPropNameInTable="ped_longitudColumn" msprop:Generator_UserColumnName="ped_longitud" type="xs:decimal" minOccurs="0" />
              <xs:element name="ped_fecha_inicio" msprop:Generator_ColumnVarNameInTable="columnped_fecha_inicio" msprop:Generator_ColumnPropNameInRow="ped_fecha_inicio" msprop:Generator_ColumnPropNameInTable="ped_fecha_inicioColumn" msprop:Generator_UserColumnName="ped_fecha_inicio" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ped_fecha_fin" msprop:Generator_ColumnVarNameInTable="columnped_fecha_fin" msprop:Generator_ColumnPropNameInRow="ped_fecha_fin" msprop:Generator_ColumnPropNameInTable="ped_fecha_finColumn" msprop:Generator_UserColumnName="ped_fecha_fin" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ped_estado" msprop:Generator_ColumnVarNameInTable="columnped_estado" msprop:Generator_ColumnPropNameInRow="ped_estado" msprop:Generator_ColumnPropNameInTable="ped_estadoColumn" msprop:Generator_UserColumnName="ped_estado" type="xs:int" minOccurs="0" />
              <xs:element name="ped_id_usu_descarga" msprop:Generator_ColumnVarNameInTable="columnped_id_usu_descarga" msprop:Generator_ColumnPropNameInRow="ped_id_usu_descarga" msprop:Generator_ColumnPropNameInTable="ped_id_usu_descargaColumn" msprop:Generator_UserColumnName="ped_id_usu_descarga" type="xs:int" minOccurs="0" />
              <xs:element name="ped_fecha_descarga" msprop:Generator_ColumnVarNameInTable="columnped_fecha_descarga" msprop:Generator_ColumnPropNameInRow="ped_fecha_descarga" msprop:Generator_ColumnPropNameInTable="ped_fecha_descargaColumn" msprop:Generator_UserColumnName="ped_fecha_descarga" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PED_PEDIDO" />
      <xs:field xpath="mstns:ped_id" />
    </xs:unique>
  </xs:element>
</xs:schema>